Cannot group on fields selected with '*' <table name>. (Error 3120)

You tried to execute a SELECT statement that groups or totals all fields in a single table, selected with an asterisk ( * ). This error occurs, for example, if you enter the following SQL statement:

SELECT Orders.* FROM Orders GROUP BY ShipVia;